Any nvarchar column content is shown as <binary> when using table browsing or view from enterprise manager in SQL Server 2000.

I starting using a new laptop and checked all my sql settings however when I run the same script on my old laptop and new laptop and save to file as text, the data is exactly the same but it is much larger on my new laptop. What setting am I missing on my new…

ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

ERROR 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 2 SQL Statement: CREATE  TABLE `cape codd`.`SKU_DATA` ( )   Does anyone know how to fix or workaround this? thanks Whitney Ferrante

Hi All I am facing some problems with charts in ssrs 2005. i have inserted 5 graphs in report.Each graph is set by filter.When i run the report ,it is giving some blank spaces if chart doesnt have any values.So how can i solve my problem. Any help would be appreciated . Regards, Anitha

Hi All I am facing some problems with charts in ssrs 2005. i have inserted 5 graphs in report.Each graph is set by filter.When i run the report ,it is giving some blank spaces if chart doesnt have any values.So how can i solve my problem. Any help would be appreciated . Regards, Anitha

As part of a new feature on the Community Blog, each week we’ll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an…

Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to remove…

Once again, we’ve compiled the 10 most watched questions on ITKE, and found some great discussions on topics ranging from virtualization to disaster recovery to disaster recovery. Go answer a question now and you could win a TV, or check out the rest of the top 10 on the Community Blog: 1. How to remove…

I am desiging a report to use several parameters. The first parm is report type. I need the other parameters to show or hide depending on the selection made to the first parameter. Can anyone help? Thanks

I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don’t know if there is a way I…

I am have troble trying to get a select all fuction using AS/400 data on Mircosoft reporting services. Normally I know you just go into the parameter and click multivalued but that is not working. I have create a Stored procedure to use the calender feature for date I don’t know if there is a way I…

In bulk-logged recovery mode in SQL Server, how can you restore to the end of a log backup that includes a bulk event? It seems to me that everything after the bulk event is useless. How could I do this?

In bulk-logged recovery mode in SQL Server, how can you restore to the end of a log backup that includes a bulk event? It seems to me that everything after the bulk event is useless. How could I do this?

Using STANDARD REPORT CREATION WIZARD, I connected to UNIVERSES Data Sources and RUN a querry in BUSINESS OBJECTS QUERY PANEL, When I pull in fields from the universe into the query panel. But, the minute they hit “OK” they get and error that says “Login Failed.” i am getting ERROR Message “Failed to Retrieve SQL”.What…

Using STANDARD REPORT CREATION WIZARD, I connected to UNIVERSES Data Sources and RUN a querry in BUSINESS OBJECTS QUERY PANEL, When I pull in fields from the universe into the query panel. But, the minute they hit “OK” they get and error that says “Login Failed.” i am getting ERROR Message “Failed to Retrieve SQL”.What…

Here are the 10 most watched questions on ITKE: There’s some great discussions going on ranging from going green to how to create a new network. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1. Going green:…

Hi Mrdenny, I have as GIG. I have a Database Full Backup Maintenance Plan that fails to execute, and I get the same error as GIG’s. I checked my disk and I think there is enough free space available (471GB). What could be causing the full backup to fail? Please help! Thanks in advance.

I have am MS Access (VBA) program where I need to create a table on a SQL Server database then append data to the table. I have the code that generates the update query but I need the ADO code that creates the connection to the SQL Server 2005 database then I need the code…

I created report in ssrs 2005. i added ms report viewer in c# windows application and from smart tag i gave the report name. It display the report but how to give name dynamically, for example i want to put the report name through textbox and want to show the report at runtime.