Viewing 15 posts - 301 through 315 (of 907 total)
You could build some dynamic SQL like this. Run this code in the database you are looking for null columns. Be aware this might run awhile, depending on...
April 18, 2003 at 9:23 am
You can get the description for each field in a table using the following TSQL:
select objname column_name, value Description from ::fn_listextendedproperty(NULL, N'user', N'dbo', N'table', N'<your table>', 'column',default)
Gregory Larsen, DBA
If you...
April 17, 2003 at 2:10 pm
You can find a couple of examples on how to pad with zeros here:
http://www.geocities.com/sqlserverexamples#string4
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
April 17, 2003 at 9:58 am
I tried it with a user that had no permissions to anything, and it still seems to return data. What version of SQL Server are you running? I...
April 17, 2003 at 9:09 am
Anyone that has execute permissions on a stored proc can update the tables the SP updates, even if the user does not have permissions to update the table.
Gregory Larsen, DBA
If...
April 16, 2003 at 5:08 pm
Is it a SQL Agent job that runs the script?
Or something else. Why is it currently not working?
Gregory Larsen, DBA
If you looking for SQL Server Examples check out...
April 16, 2003 at 4:53 pm
Cross-post, check out my comment in this thread:
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=11294
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
April 16, 2003 at 4:12 pm
How are you displaying the results? If you are using QA then you might need to adjust the "maximum characters per column" on the results tab on the options...
April 16, 2003 at 4:10 pm
Might try something like this:
insert into <your table> select column_name, column_default from information_schema.columns
where table_name = '<table with default values>'
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my...
April 16, 2003 at 3:56 pm
Type the complete path name to the exe. I think somethjng like:
exec xp_cmdshell 'c:\program files\pkzip.pkzipc -add c:\test.zip c:\test.txt'
Gregory Larsen, DBA
If you looking for SQL Server Examples check out...
April 16, 2003 at 3:37 pm
As far as I know, XP_CMDSHELL will only run under the account that MSSQLSERVER is running under.
Gregory Larsen, DBA
If you looking for SQL Server Examples check out my website at...
April 16, 2003 at 2:54 pm
Took CQL's concept and created solution without union. Don't try this at home......it is not as fast, and I pulled a little hair out trying to write this weird...
April 16, 2003 at 1:58 pm
Now there is an interesting twist to get the max date between two different dates. Great way to eliminate multiple pass of the data.
Gregory Larsen, DBA
If you looking for...
April 16, 2003 at 12:57 pm
Here is the test I ran. The memory table consistantly takes longer. Now this is only on a small set of records. I replicated the insert statements...
April 16, 2003 at 9:28 am
Your method works as well and might be easier to read, but my quick test suggests it takes about twices as long as the set based UNION example.
Guess it depends...
April 15, 2003 at 3:06 pm
Viewing 15 posts - 301 through 315 (of 907 total)