Hello,

Open up SSMS using a Login who is in the SysAdmin role on the SQL Server e.g. a Member of the Administrators Group on the Windows Server.

In the Object Explorer...

Hello,

If you don’t already have scripts of your SPs then you can use a tool such as SSMS (SQL Server Management Studio) to generate them. (Preferably then store the scripts...

Hello Greg,

You are right about the Clustered Index:-

1) As the Table data is contained within the Clustered Index, you are no longer able to access the Table if it...

Hello,

Does the following Microsoft KB Article relate to your issue:-

http://support.microsoft.com/kb/811484

Regards,

John Marsh

Hello,

Is it the Data File(s) or Log File that grows? What Recovery Model does the Database have? How are you rebuilding the indexes (with DBCC DBREINDEX perhaps)?

Regards,

John Marsh

Hello,

Do you have more than one Parameter on the Report? As often this error can be resolved by changing the order of the Parameters in the Report.

Regards,

John Marsh

Hello,

There are other pre-requisites to ensure Bulk Insert operations are minimally logged, apart from setting the Recovery Model. I would assume from the growth of your Transaction Log that one...

Hello,

If you check the DB Properties via SSMS, what are the values in the State section e.g. is the DB in Multi or Single User Mode?

Do you have any errors...

Hello again,

There are a couple of Threads around relating to the Error Message that you receive which suggest it could be a problem with the Driver your ISP is using....

Hello,

It is quite possible that your VB Application will work with SQL 2008 just as well as it did with 2000. Particularly if you were just using SQL Server for...

Hello,

You just need to specify the Instance Name after the Server Name e.g. MyServer\MyInstance.

You can use both a Default and a Named Instance simultaneously.

Regards,

John Marsh

Hello again,

As an attempt at a quick fix you could try disabling "Force Protocol Encryption" in the SQL Server Network Utility.

If that doesn’t work then have a look at this...

Hello again,

If you need to learn SQL Server from a Developer perspective then personally I would recommend using one of the more modern Express Edition versions. The differences are not...

Hello,

Is SQL Server returning an error message to the Linux Machine, or can you see any Logon Failures in the SQL Server Log? If so, please post an example.

Using the...

Hello,

Is the Column in your Table set as “Not Null“ or “ANSI_Padding On”?

In either of these cases you will have problems because the data will have been padded with trailing...